﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Agresso.Interface.Layer.SQL
{
    public class ResponsibleUserSQL
    {
        public static string FindBySoftmarName()
        {
            return "Select * from i_ResponsibleUser where softmar_user=@softmar_user";
        }

        public static string Insert()
        {
            return "insert into i_ResponsibleUser (softmar_user, agresso_user) values (@softmar_user, @agresso_user)";
        }

        public static string GetMaxID()
        {
            return "select max(ResponsibleUser_id) from i_ResponsibleUser";
        }

        public static string GetAllUser()
        {
            return "select * from i_ResponsibleUser order by softmar_user";
        }

        public static string UpdateResponsibleUser()
        {
            return "update i_ResponsibleUser set agresso_user=@agresso_user where ResponsibleUser_id=@ResponsibleUser_id";
        }
    }
}
